<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10" interactivePageBreakByFrame="true"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>NAS Subscribed</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:175px;height:200px;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Over-subscribed Capacity</staticValue></dataSource><style><CSS value="color:gray"/></style></textItem></contents><style><CSS value="padding-right:10px;padding-left:10px;padding-top:5px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Overall Subscribed"/></dataSource><style><CSS value="font-size:24px;font-weight:bold;font-family:Arial;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Savings: </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton2" refQuery="Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Thin Savings (TB)"/></dataSource><style><CSS value="color:gray;font-weight:bold;font-size:8pt"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Volume Count:  </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton3" refQuery="Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Volume Count"/></dataSource><style><CSS value="font-weight:bold;color:gray;font-size:8pt"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_gaugeChart gaugeEndAngle="180" gaugeStartAngle="360" maxHotspots="10000" name="Pie Chart12" refQuery="Capacity">
                                                                                                        <v2_basicTooltips/>
                                                                                                        <v2_gaugeAxes>
                                                                                                            <v2_gaugeAxis gaugeAxisEndAngle="30" gaugeAxisInnerRadius="65" gaugeAxisOuterRadius="100" gaugeAxisStartAngle="150">
                                                                                                                <v2_axisRange scale="linear">
                                                                                                                    
                                                                                                                <v2_specifiedRange max="2" min="0" includeZeroForAutoScale="true" scaleInterval="0.20"/></v2_axisRange>
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                <v2_gaugeNeedle needleBevelStyle="flat" needleHeadLength="100" needleHeadStyle="triangular" needleHeadWidth="1" needlePivotWidth="12" needleTailLength="0" needleTailWidth="0">
                                                                                                                    
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <v2_solidPalette>
                                                                                                                        <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#E5B09E">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#E5B09E"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A07B6F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A1A1AA">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A1A1AA"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#717177"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#9DBFE0">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#9DBFE0"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#6E869D"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C29ACC">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C29ACC"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#886C8F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#80C1BB">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#80C1BB"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#5A8783"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C65F71">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C65F71"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#8B424F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#ECC57C">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#ECC57C"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A58A57"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A08689">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A08689"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#705E60"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#B6D994">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#B6D994"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#7F9868"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                        </v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Overall Subscribed"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_gaugeNeedle>
                                                                                                            <v2_axisColors><v2_gradientColor gradientColor="#9AD7CD"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="58.99"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="59"/><v2_gradientColor gradientColor="white" colorPosition="60"/><v2_gradientColor colorPosition="61" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="78.99" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="79" gradientColor="#FFFFFF"/><v2_gradientColor colorPosition="80" gradientColor="#FFB2C1"/><v2_gradientColor gradientColor="#FFB2C1" colorPosition="100"/></v2_axisColors></v2_gaugeAxis>
                                                                                                        </v2_gaugeAxes>
                                                                                                        <style>
                                                                                                            <CSS value="width:160px;height:100px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
                                                                                                        <noDataHandler>
                                                                                                            <contents>
                                                                                                                <block>
                                                                                                                    <contents>
                                                                                                                        <textItem>
                                                                                                                            <dataSource>
                                                                                                                                <staticValue>No Data Available</staticValue>
                                                                                                                            </dataSource>
                                                                                                                            <style>
                                                                                                                                <CSS value="padding:10px 18px;"/>
                                                                                                                            </style>
                                                                                                                        </textItem>
                                                                                                                    </contents>
                                                                                                                </block>
                                                                                                            </contents>
                                                                                                        </noDataHandler>
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_pivot pivotBevelRadius="0" pivotBevelStyle="flat" pivotColor="#6198C5" pivotRadius="5"/><v2_notes><v2_note refQuery="Capacity"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>0%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="-40px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note><v2_note refQuery="Capacity"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>200%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="50px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_gaugeChart></contents><style><CSS value="text-align:center;padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-bottom:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:175px;height:200px;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Used Capacity</staticValue></dataSource><style><CSS value="color:gray"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Capacity Summary">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used %"/></dataSource><style><CSS value="font-size:24px;font-weight:bold;font-family:Arial;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Usable: </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton5" refQuery="Capacity Summary">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource><style><CSS value="font-size:8pt;color:gray;font-weight:bold"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Allocated: </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton6" refQuery="Capacity Summary">
			<contents><textItem><dataSource><dataItemValue refDataItem="Internal Volume Allocated Capacity (TB)"/></dataSource><style><CSS value="color:gray;font-size:8pt;font-weight:bold"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_gaugeChart gaugeEndAngle="180" gaugeStartAngle="360" maxHotspots="10000" name="Pie Chart16" refQuery="Capacity Summary">
                                                                                                        <v2_basicTooltips/>
                                                                                                        <v2_gaugeAxes>
                                                                                                            <v2_gaugeAxis gaugeAxisEndAngle="30" gaugeAxisInnerRadius="65" gaugeAxisOuterRadius="100" gaugeAxisStartAngle="150">
                                                                                                                <v2_axisRange scale="linear">
                                                                                                                    
                                                                                                                <v2_specifiedRange max="2" min="0" includeZeroForAutoScale="true" scaleInterval="0.20"/></v2_axisRange>
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                <v2_gaugeNeedle needleBevelStyle="flat" needleHeadLength="100" needleHeadStyle="triangular" needleHeadWidth="1" needlePivotWidth="12" needleTailLength="0" needleTailWidth="0">
                                                                                                                    
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <v2_solidPalette>
                                                                                                                        <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#E5B09E">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#E5B09E"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A07B6F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A1A1AA">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A1A1AA"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#717177"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#9DBFE0">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#9DBFE0"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#6E869D"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C29ACC">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C29ACC"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#886C8F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#80C1BB">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#80C1BB"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#5A8783"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C65F71">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C65F71"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#8B424F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#ECC57C">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#ECC57C"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A58A57"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A08689">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A08689"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#705E60"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#B6D994">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#B6D994"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#7F9868"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                        </v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_gaugeNeedle>
                                                                                                            <v2_axisColors><v2_gradientColor gradientColor="#9AD7CD"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="58.99"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="59"/><v2_gradientColor gradientColor="white" colorPosition="60"/><v2_gradientColor colorPosition="61" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="78.99" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="79" gradientColor="#FFFFFF"/><v2_gradientColor colorPosition="80" gradientColor="#FFB2C1"/><v2_gradientColor gradientColor="#FFB2C1" colorPosition="100"/></v2_axisColors></v2_gaugeAxis>
                                                                                                        </v2_gaugeAxes>
                                                                                                        <style>
                                                                                                            <CSS value="width:160px;height:100px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
                                                                                                        <noDataHandler>
                                                                                                            <contents>
                                                                                                                <block>
                                                                                                                    <contents>
                                                                                                                        <textItem>
                                                                                                                            <dataSource>
                                                                                                                                <staticValue>No Data Available</staticValue>
                                                                                                                            </dataSource>
                                                                                                                            <style>
                                                                                                                                <CSS value="padding:10px 18px;"/>
                                                                                                                            </style>
                                                                                                                        </textItem>
                                                                                                                    </contents>
                                                                                                                </block>
                                                                                                            </contents>
                                                                                                        </noDataHandler>
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_pivot pivotBevelRadius="0" pivotBevelStyle="flat" pivotColor="#6198C5" pivotRadius="5"/><v2_notes><v2_note refQuery="Capacity Summary"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>0%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="-40px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note><v2_note refQuery="Capacity Summary"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>100%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="50px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_gaugeChart></contents><style><CSS value="text-align:center;padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top;padding-bottom:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:175px;height:200px;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Average CPU Utilization %</staticValue></dataSource><style><CSS value="color:gray"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton7" refQuery="Node Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="CPU %"/></dataSource><style><CSS value="font-size:24px;font-weight:bold;font-family:Arial;color:#808080"/><dataFormat><numberFormat pattern="###' %'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg Node IOpS: </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton8" refQuery="Node Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total IOpS"/></dataSource><style><CSS value="font-size:8pt;color:gray;font-weight:bold"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg Node Latency: </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton9" refQuery="Node Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Latency (ms)"/></dataSource><style><CSS value="font-size:8pt;color:gray;font-weight:bold"/><dataFormat><numberFormat pattern="###.##' ms'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_gaugeChart gaugeEndAngle="180" gaugeStartAngle="360" maxHotspots="10000" name="Pie Chart17" refQuery="Node Perf">
                                                                                                        <v2_basicTooltips/>
                                                                                                        <v2_gaugeAxes>
                                                                                                            <v2_gaugeAxis gaugeAxisEndAngle="30" gaugeAxisInnerRadius="65" gaugeAxisOuterRadius="100" gaugeAxisStartAngle="150">
                                                                                                                <v2_axisRange scale="linear">
                                                                                                                    
                                                                                                                <v2_specifiedRange max="100" min="0" includeZeroForAutoScale="true"/></v2_axisRange>
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                <v2_gaugeNeedle needleBevelStyle="flat" needleHeadLength="100" needleHeadStyle="triangular" needleHeadWidth="1" needlePivotWidth="12" needleTailLength="0" needleTailWidth="0">
                                                                                                                    
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <v2_solidPalette>
                                                                                                                        <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#E5B09E">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#E5B09E"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A07B6F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A1A1AA">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A1A1AA"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#717177"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#9DBFE0">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#9DBFE0"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#6E869D"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C29ACC">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C29ACC"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#886C8F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#80C1BB">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#80C1BB"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#5A8783"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C65F71">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C65F71"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#8B424F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#ECC57C">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#ECC57C"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A58A57"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A08689">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A08689"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#705E60"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#B6D994">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#B6D994"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#7F9868"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                        </v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="CPU %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_gaugeNeedle>
                                                                                                            <v2_axisColors><v2_gradientColor gradientColor="#9AD7CD"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="58.99"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="59"/><v2_gradientColor gradientColor="white" colorPosition="60"/><v2_gradientColor colorPosition="61" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="78.99" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="79" gradientColor="#FFFFFF"/><v2_gradientColor colorPosition="80" gradientColor="#FFB2C1"/><v2_gradientColor gradientColor="#FFB2C1" colorPosition="100"/></v2_axisColors></v2_gaugeAxis>
                                                                                                        </v2_gaugeAxes>
                                                                                                        <style>
                                                                                                            <CSS value="width:160px;height:100px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
                                                                                                        <noDataHandler>
                                                                                                            <contents>
                                                                                                                <block>
                                                                                                                    <contents>
                                                                                                                        <textItem>
                                                                                                                            <dataSource>
                                                                                                                                <staticValue>No Data Available</staticValue>
                                                                                                                            </dataSource>
                                                                                                                            <style>
                                                                                                                                <CSS value="padding:10px 18px;"/>
                                                                                                                            </style>
                                                                                                                        </textItem>
                                                                                                                    </contents>
                                                                                                                </block>
                                                                                                            </contents>
                                                                                                        </noDataHandler>
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_pivot pivotBevelRadius="0" pivotBevelStyle="flat" pivotColor="#6198C5" pivotRadius="5"/><v2_notes><v2_note refQuery="Node Perf"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>0%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="-40px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note><v2_note refQuery="Node Perf"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>100%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="50px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_gaugeChart></contents><style><CSS value="text-align:center;padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top;padding-bottom:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:175px;height:200px;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Average Disk Utilization %</staticValue></dataSource><style><CSS value="color:gray"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton10" refQuery="Disk Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Utilization"/></dataSource><style><CSS value="font-size:24px;font-weight:bold;font-family:Arial;color:#808080"/><dataFormat><numberFormat pattern="###' %'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg Disk IOpS: </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton11" refQuery="Disk Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total IOps"/></dataSource><style><CSS value="font-size:8pt;color:gray;font-weight:bold"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg MBps: </staticValue></dataSource><style><CSS value="color:gray;font-weight:normal;font-size:8pt"/></style></textItem><singleton name="Singleton12" refQuery="Disk Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total MBps"/></dataSource><style><CSS value="font-size:8pt;color:gray;font-weight:bold"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_gaugeChart gaugeEndAngle="180" gaugeStartAngle="360" maxHotspots="10000" name="Pie Chart18" refQuery="Disk Perf">
                                                                                                        <v2_basicTooltips/>
                                                                                                        <v2_gaugeAxes>
                                                                                                            <v2_gaugeAxis gaugeAxisEndAngle="30" gaugeAxisInnerRadius="65" gaugeAxisOuterRadius="100" gaugeAxisStartAngle="150">
                                                                                                                <v2_axisRange scale="linear">
                                                                                                                    
                                                                                                                <v2_specifiedRange max="100" min="0" includeZeroForAutoScale="true"/></v2_axisRange>
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                
                                                                                                                <v2_gaugeNeedle needleBevelStyle="flat" needleHeadLength="100" needleHeadStyle="triangular" needleHeadWidth="1" needlePivotWidth="12" needleTailLength="0" needleTailWidth="0">
                                                                                                                    
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <v2_solidPalette>
                                                                                                                        <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#E5B09E">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#E5B09E"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A07B6F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A1A1AA">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A1A1AA"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#717177"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#9DBFE0">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#9DBFE0"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#6E869D"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C29ACC">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C29ACC"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#886C8F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#80C1BB">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#80C1BB"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#5A8783"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#C65F71">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#C65F71"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#8B424F"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#ECC57C">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#ECC57C"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#A58A57"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#A08689">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#A08689"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#705E60"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                            <v2_solidPaletteEntry>
                                                                                                                                <v2_fillEffect defaultColor="#B6D994">
                                                                                                                                    <v2_linearGradient gradientAngle="270">
                                                                                                                                        <v2_gradientColor gradientColor="#B6D994"/>
                                                                                                                                        <v2_gradientColor colorPosition="100" gradientColor="#7F9868"/>
                                                                                                                                    </v2_linearGradient>
                                                                                                                                </v2_fillEffect>
                                                                                                                            </v2_solidPaletteEntry>
                                                                                                                        </v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Utilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_gaugeNeedle>
                                                                                                            <v2_axisColors><v2_gradientColor gradientColor="#9AD7CD"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="58.99"/><v2_gradientColor gradientColor="#9AD7CD" colorPosition="59"/><v2_gradientColor gradientColor="white" colorPosition="60"/><v2_gradientColor colorPosition="61" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="78.99" gradientColor="rgb(255,194,102)"/><v2_gradientColor colorPosition="79" gradientColor="#FFFFFF"/><v2_gradientColor colorPosition="80" gradientColor="#FFB2C1"/><v2_gradientColor gradientColor="#FFB2C1" colorPosition="100"/></v2_axisColors></v2_gaugeAxis>
                                                                                                        </v2_gaugeAxes>
                                                                                                        <style>
                                                                                                            <CSS value="width:160px;height:100px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
                                                                                                        <noDataHandler>
                                                                                                            <contents>
                                                                                                                <block>
                                                                                                                    <contents>
                                                                                                                        <textItem>
                                                                                                                            <dataSource>
                                                                                                                                <staticValue>No Data Available</staticValue>
                                                                                                                            </dataSource>
                                                                                                                            <style>
                                                                                                                                <CSS value="padding:10px 18px;"/>
                                                                                                                            </style>
                                                                                                                        </textItem>
                                                                                                                    </contents>
                                                                                                                </block>
                                                                                                            </contents>
                                                                                                        </noDataHandler>
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_pivot pivotBevelRadius="0" pivotBevelStyle="flat" pivotColor="#6198C5" pivotRadius="5"/><v2_notes><v2_note refQuery="Disk Perf"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>0%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="-40px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note><v2_note refQuery="Disk Perf"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>100%</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="-30px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="50px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_gaugeChart></contents><style><CSS value="text-align:center;padding-right:10px;padding-left:10px;background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Thin Subscription Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(for NetApp Aggregates)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><block>
			<contents><list horizontalPagination="true" name="List1" refQuery="Capacity" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;table-layout:fixed;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:125px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:125px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:125px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:125px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Internal Volume Allocated Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Internal Volume Allocated Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Subscription %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Subscription %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin Savings (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin Savings (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
		<style><CSS value="width:705px;overflow:hidden;height:45px"/></style></block></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents><list horizontalPagination="true" name="List2" refQuery="Capacity" rowsPerPage="5000" showColumnTitles="hide">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;table-layout:fixed;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:125px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:125px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Internal Volume Allocated Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Internal Volume Allocated Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Subscription %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Subscription %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin Savings (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin Savings (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
		<style><CSS value="height:250px;overflow:auto;width:721px;border-bottom:1pt solid silver"/></style></block></contents><style><CSS value="padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:5px;padding-bottom:5px;background-color:#F7F7F7;padding-left:10px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Over-Subscribed Aggregates</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by %)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top N Aggregates Subscribed" name="Combination Chart1" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Pool Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Subscription %"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar borders="hide" setOrdinalWidthScale="80" bevel="none" borderColor="black" barShape="box">
																																			<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Subscription %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:645px;height:250px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Aggregate Days to Full</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Less than 365 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;width:300px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Pools Days to Full" name="Combination Chart2" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						<v2_commonAxis>
																																							<v2_ordinalAxis>
																																								<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_ordinalAxis>
																																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Pool"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borders="hide" setOrdinalWidthScale="80" bevel="none" borderColor="black" barShape="box">
																																									<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Days to Full"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<dataFormat><numberFormat pattern="###' Days'"/></dataFormat><CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:300px;height:202px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						
																																						</v2_combinationChart>
																																				</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Utilization Forecast</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(All NetApp Arrays)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;width:300px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="Forecast">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					<v2_labelControl displayFrequency="2"/></v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd/y)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Projected Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:298px;height:202px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top;background-color:#F7F7F7;padding-right:10px"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell colSpan="2"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Thin Workloads</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Used Capacity %)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top N Thin Workloads" name="Combination Chart5" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar borders="hide" setOrdinalWidthScale="80" bevel="none" borderColor="black" barShape="box">
																																			<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:347px;height:203px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-bottom:10px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Aggregates at Risk</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(80% Physical Used)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Aggs at Risk" name="Combination Chart6" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles><CSS value="color:#454545"/></style><v2_legendPosition><v2_legendPreset legendPositionPreset="bottom"/></v2_legendPosition></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Pool Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar borders="hide" setOrdinalWidthScale="80" bevel="none" borderColor="black" barShape="box">
																																			<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Subscription %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
																</v2_axisLabels></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:347px;height:203px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top;padding-bottom:10px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Available Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(for Thin Provisioning)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<block>
			<contents><list horizontalPagination="true" name="List3" refQuery="Report" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin/Thick"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin/Thick"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Usable (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Usable (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Used"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Used"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Available for Thin Provisioning (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Available for Thin Provisioning (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cost Savings"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><currencyFormat decimalSize="0"/></dataFormat><CSS value="color:green;font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cost Savings"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
		<style><CSS value="width:620px;height:178px;overflow:auto"/></style></block><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;visibility:visible"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Provision Projection %: </staticValue></dataSource><style><CSS value="color:#333333;font-weight:normal;font-size:8pt"/></style></textItem></contents></tableCell><tableCell><contents><textBox parameter="sThin" required="false" numbersOnly="true"><style><CSS value="width:45px;height:20px;direction:rtl"/></style><defaultSelections><defaultSimpleSelection>10</defaultSimpleSelection></defaultSelections></textBox></contents></tableCell><tableCell><contents/></tableCell><tableCell><contents><textItem><dataSource><staticValue>Cost Override ($K/TB): </staticValue></dataSource><style><CSS value="color:#333333;font-weight:normal;font-size:8pt"/></style></textItem></contents><style><CSS value="padding-left:10px"/></style></tableCell><tableCell><contents><textBox parameter="sThinCost" required="false" numbersOnly="true"><style><CSS value="width:45px;height:20px;direction:rtl"/></style><defaultSelections><defaultSimpleSelection>5</defaultSimpleSelection></defaultSelections></textBox></contents></tableCell><tableCell><contents><textItem><dataSource><staticValue>Used % Threshold: </staticValue></dataSource><style><CSS value="color:#333333;font-weight:normal;font-size:8pt"/></style></textItem></contents><style><CSS value="padding-left:10px"/></style></tableCell><tableCell><contents><textBox required="false" numbersOnly="true" parameter="sTop"><style><CSS value="width:45px;height:20px;direction:rtl"/></style><defaultSelections><defaultSimpleSelection>60</defaultSimpleSelection></defaultSelections></textBox></contents></tableCell><tableCell><contents/></tableCell><tableCell><contents><promptButton type="next">
			<contents><textItem><dataSource><staticValue>Refresh</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-left:10px;padding-right:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.20 NAS Subscribed</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Capacity">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',-1) as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',


                     (SELECT count(*) FROM dwh_inventory.internal_volume JOIN dwh_inventory.storage_pool ON dwh_inventory.storage_pool.id=dwh_inventory.internal_volume.storagepoolid
                        AND dwh_inventory.internal_volume.thinprovisioned=1
                      ) as 'Volume Count',

	
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	-- ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',


	(
	SELECT 	
		ROUND(SUM(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB)/1024/1024,2)
		
	FROM 	dwh_capacity.internal_volume_capacity_fact
	JOIN 	dwh_capacity.storage_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_capacity.internal_volume_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1

	WHERE dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

	GROUP BY dwh_capacity.storage_pool_dimension.tk ) as 'Internal Volume Allocated Capacity (TB)',
	

	NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'Projected Capacity (TB)',
	NULL AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
AND              dwh_capacity.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Volume Count"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Projected Raw Capacity (TB)"/><mdProjectedItem name="Projected Capacity (TB)"/><mdProjectedItem name="Projected Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Pool Name" label="Aggregate"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL1].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[SQL1].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total" label="Usable (TB)"><expression>[SQL1].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total" label="Used (TB)"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL1].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Consumed Capacity (TB)"><expression>[SQL1].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)" label="Allocated (TB)"><expression>[SQL1].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL1].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Capacity (TB)"><expression>[SQL1].[Projected Raw Capacity (TB)]</expression></dataItem><dataItem name="Projected Capacity (TB)"><expression>[SQL1].[Projected Capacity (TB)]</expression></dataItem><dataItem name="Projected Used Capacity (TB)"><expression>[SQL1].[Projected Used Capacity (TB)]</expression></dataItem><dataItem name="Subscription %"><expression>([Internal Volume Allocated Capacity (TB)]/[Capacity (TB)])</expression></dataItem><dataItem name="Used %"><expression>[Used Capacity (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="Overall Subscribed"><expression>total([Internal Volume Allocated Capacity (TB)] for report) / total([Capacity (TB)] for report)</expression></dataItem><dataItem name="Thin Savings (TB)" aggregate="total"><expression>IF([Subscription %]&gt;1) THEN (([Subscription %]-1)*[Capacity (TB)]) ELSE (0)</expression></dataItem><dataItem name="Volume Count"><expression>[SQL1].[Volume Count]</expression></dataItem></selection>
		</query><query name="Forecast">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',-1) as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'Projected Capacity (TB)',
	NULL AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
AND              dwh_capacity.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
UNION
SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	NULL AS 'Raw Capacity (TB)',
	NULL AS 'Capacity (TB)',
	NULL AS 'Used Capacity (TB)',
	NULL AS 'Provisioned (TB)',
	NULL AS 'Volume Consumed Capacity (TB)',
	NULL AS 'Internal Volume Allocated Capacity (TB)',
	NULL AS 'Internal Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.rawcapacityMB)/1024/1024, 2) AS 'Projected Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.capacityMB)/1024/1024, 2) AS 'Projected Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedCapacityMB)/1024/1024, 2) AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_future_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
AND              dwh_capacity.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/><mdProjectedItem name="Projected Raw Capacity (TB)"/><mdProjectedItem name="Projected Capacity (TB)"/><mdProjectedItem name="Projected Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL2].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL2].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL2].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL2].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL2].[Cost]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[SQL2].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)"><expression>[SQL2].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL2].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL2].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Consumed Capacity (TB)"><expression>[SQL2].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)"><expression>[SQL2].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL2].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Capacity (TB)"><expression>[SQL2].[Projected Raw Capacity (TB)]</expression></dataItem><dataItem name="Projected Capacity (TB)"><expression>[SQL2].[Projected Capacity (TB)]</expression></dataItem><dataItem name="Projected Used Capacity (TB)" aggregate="total"><expression>[SQL2].[Projected Used Capacity (TB)]</expression></dataItem><dataItem name="Subscription %"><expression>[Internal Volume Allocated Capacity (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="Used %"><expression>[Used Capacity (TB)]/[Capacity (TB)]</expression></dataItem></selection>
		</query><query name="Capacity Summary">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	
	
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)'
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
AND              dwh_capacity.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Raw Capacity (TB)"><expression>[SQL3].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL3].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL3].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL3].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Consumed Capacity (TB)"><expression>[SQL3].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)" aggregate="total"><expression>[SQL3].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL3].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Used %"><expression>[Used Capacity (TB)]/[Capacity (TB)]</expression></dataItem></selection>
		</query><query name="Node Perf">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.storage_node_hourly_performance_fact.totaliops as 'Total IOpS',
dwh_performance.storage_node_hourly_performance_fact.totalresponsetime as 'Latency (ms)',
dwh_performance.storage_node_hourly_performance_fact.totalthroughput as 'Total MBps',

dwh_performance.storage_node_hourly_performance_fact.utilization as 'CPU %',
dwh_performance.storage_node_hourly_performance_fact.diskreadsreplaced as 'Disk Reads Replaced',
dwh_performance.storage_node_hourly_performance_fact.cachehitratio as 'Cache Hit Ratio',



dwh_performance.time_dimension.hourdatetime as 'Time'

FROM dwh_performance.storage_node_hourly_performance_fact
JOIN  dwh_performance.time_dimension
ON     dwh_performance.time_dimension.tk=dwh_performance.storage_node_hourly_performance_fact.timetk

GROUP BY dwh_performance.time_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Latency (ms)"/><mdProjectedItem name="Total MBps"/><mdProjectedItem name="CPU %"/><mdProjectedItem name="Disk Reads Replaced"/><mdProjectedItem name="Cache Hit Ratio"/><mdProjectedItem name="Time"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Total IOpS" aggregate="average"><expression>[SQL4].[Total IOpS]</expression></dataItem><dataItem name="Latency (ms)" aggregate="average"><expression>[SQL4].[Latency (ms)]</expression></dataItem><dataItem name="Total MBps"><expression>[SQL4].[Total MBps]</expression></dataItem><dataItem name="CPU %" aggregate="average"><expression>[SQL4].[CPU %]</expression></dataItem><dataItem name="Disk Reads Replaced"><expression>[SQL4].[Disk Reads Replaced]</expression></dataItem><dataItem name="Cache Hit Ratio"><expression>[SQL4].[Cache Hit Ratio]</expression></dataItem><dataItem name="Time"><expression>[SQL4].[Time]</expression></dataItem></selection>
		</query><query name="Disk Perf">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
ROUND(MAX(dwh_performance.disk_hourly_performance_fact.totalUtilization),0) as 'Utilization',
ROUND(MAX(dwh_performance.disk_hourly_performance_fact.totaliops),0) as 'Total IOps',
ROUND(MAX(dwh_performance.disk_hourly_performance_fact.totalthroughput),0) 'Total MBps'

FROM dwh_performance.disk_hourly_performance_fact
JOIN  dwh_performance.storage_dimension
ON    dwh_performance.storage_dimension.tk=dwh_performance.disk_hourly_performance_fact.storagetk
AND  dwh_performance.storage_dimension.manufacturer='netapp'
JOIN dwh_performance.storage_pool_dimension
ON   dwh_performance.storage_pool_dimension.tk=dwh_performance.disk_hourly_performance_fact.storagepooltk
AND dwh_performance.storage_pool_dimension.name&lt;&gt;'N/A'
AND dwh_performance.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')</sqlText>
		<mdProjectedItems><mdProjectedItem name="Utilization"/><mdProjectedItem name="Total IOps"/><mdProjectedItem name="Total MBps"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Utilization" aggregate="average"><expression>[SQL5].[Utilization]</expression></dataItem><dataItem name="Total IOps" aggregate="average"><expression>[SQL5].[Total IOps]</expression></dataItem><dataItem name="Total MBps" aggregate="average"><expression>[SQL5].[Total MBps]</expression></dataItem></selection>
		</query><query name="Top N Aggregates Subscribed"><source><sqlQuery name="SQL6" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.name as 'Storage Name',
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',-1) as 'Pool Name',
		
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)'


FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
AND              dwh_capacity.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Storage Name"><expression>[SQL6].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL6].[Pool Name]</expression></dataItem><dataItem name="Raw Capacity (TB)" aggregate="total"><expression>[SQL6].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL6].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL6].[Used Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)" aggregate="total"><expression>[SQL6].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Subscription %"><expression>([Internal Volume Allocated Capacity (TB)]/[Capacity (TB)])</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Subscription %]&gt;1</filterExpression></detailFilter></detailFilters></query><query name="Pools Days to Full">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',-1) as 'Pool',
dwh_capacity.sp_time_to_fill.daystostoragepoolfull as 'Days to Full'

FROM dwh_capacity.sp_time_to_fill
JOIN dwh_capacity.storage_and_storage_pool_capacity_fact
ON dwh_capacity.storage_and_storage_pool_capacity_fact.tk=dwh_capacity.sp_time_to_fill.saspFactTk
JOIN dwh_capacity.storage_pool_dimension
ON dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND dwh_capacity.sp_time_to_fill.daystostoragepoolfull&gt;0

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.storage_and_storage_pool_capacity_fact 
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.storage_pool_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Pool"/><mdProjectedItem name="Days to Full"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Pool"><expression>[SQL9].[Pool]</expression></dataItem><dataItem name="Days to Full" aggregate="total"><expression>[SQL9].[Days to Full]</expression></dataItem></selection>
		</query><query name="Top N Thin Workloads">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX(dwh_inventory.internal_volume.name,':',-2),':',-1) as 'Volume',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 as 'Allocated (GB)',
dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024 as 'Used (GB)',

dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/dwh_inventory.internal_volume.totalAllocatedCapacityMB as 'Used %'

FROM dwh_inventory.internal_volume
WHERE dwh_inventory.internal_volume.thinprovisioned=1

ORDER BY dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/dwh_inventory.internal_volume.totalAllocatedCapacityMB DESC LIMIT 5</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Used %"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL7].[Volume]</expression></dataItem><dataItem name="Allocated (GB)" aggregate="total"><expression>[SQL7].[Allocated (GB)]</expression></dataItem><dataItem name="Used (GB)" aggregate="total"><expression>[SQL7].[Used (GB)]</expression></dataItem><dataItem name="Used %" aggregate="total"><expression>[SQL7].[Used %]</expression></dataItem></selection>
		</query><query name="Aggs at Risk">
			<source>
				
			<queryRef refQuery="Capacity"/></source>
			<selection><dataItem name="Pool Name"><expression>[Capacity].[Pool Name]</expression></dataItem><dataItem name="Subscription %"><expression>[Capacity].[Subscription %]</expression></dataItem><dataItem name="Used %"><expression>[Capacity].[Used %]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Subscription %]&gt;1 AND [Used %]&gt;.8</filterExpression></detailFilter></detailFilters></query><query name="Report"><source><sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_dimension.name as 'Storage Name',
dwh_capacity.storage_dimension.manufacturer as 'Vendor',
dwh_capacity.storage_dimension.family as 'Family',
dwh_capacity.storage_dimension.model as 'Model',
dwh_capacity.tier_dimension.cost as 'Cost',
dwh_capacity.storage_pool_dimension.name as 'Pool/Aggregate',
IF(dwh_capacity.storage_pool_dimension.thinProvisioningSupported=1, 'Thin','Thick') as 'Thin/Thick',
ROUND((dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024,2) as 'Usable (TB)',
ROUND((dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024,2) as 'Used (TB)'

FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk
AND dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN dwh_capacity.storage_pool_dimension
ON dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN dwh_capacity.tier_dimension
ON dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1

GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk, dwh_capacity.storage_pool_dimension.thinProvisioningSupported

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Family"/><mdProjectedItem name="Model"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Pool/Aggregate"/><mdProjectedItem name="Thin/Thick"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL1].[Vendor]</expression></dataItem><dataItem name="Family"><expression>[SQL1].[Family]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Thin/Thick"><expression>[SQL1].[Thin/Thick]</expression></dataItem><dataItem name="Usable (TB)" aggregate="total"><expression>[SQL1].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem name="% Used"><expression>[Used (TB)]/[Usable (TB)]</expression></dataItem><dataItem name="Available for Thin Provisioning (TB)" label="Available for Thin (TB)"><expression>IF(
[Thin/Thick]='Thin' AND [% Used] &lt; (#prompt('sTop','Integer','60')#)/100) THEN (((#prompt('sThin','Integer','10')#)/100)*([Usable (TB)]-[Used (TB)])) ELSE (null)</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Variable Cost"><expression>IF(#prompt('sThinCost','Integer','5')#&gt;0) THEN(#prompt('sThinCost','Integer','5')#) ELSE ([Cost])</expression></dataItem><dataItem name="Cost Savings" rollupAggregate="total"><expression>([Variable Cost]*1000)*[Available for Thin Provisioning (TB)]</expression></dataItem><dataItem name="Projected Used (TB)"><expression>IF([Thin/Thick]='Thin') THEN ([Used (TB)]*((100+#prompt('sThin','Integer','10')#)/100)) ELSE ([Used (TB)]*((100-#prompt('sThin','Integer','10')#)/100))</expression></dataItem><dataItem name="Total Cost Savings (TB)"><expression>total([Cost Savings] for report)</expression></dataItem></selection></query><query name="Query1">
						<source>
							
						<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT 	dwh_capacity.storage_dimension.name AS 'Array',
	dwh_capacity.storage_pool_dimension.name AS 'Aggregate',
	ROUND((x.capacityGB), 2) AS 'Allocated Pool Capacity (GB)',
	ROUND((x.usedCapacityGB), 2) AS 'Used Pool Capacity (GB)',
	ROUND((x.usedCapacityGB)/(x.capacityGB), 2) AS 'Utilization (%)',
	ROUND(SUM(y.CapacityGB), 2) AS 'Allocated FlexVol Capacity (GB)',
	ROUND(SUM(y.CapacityGB)/(x.capacityGB), 2) AS 'Subscription (%)',
	ROUND(SUM(y.SavingsGB), 2) AS 'Dedupe Savings (GB)',
	SUM(y.SnapshotCount) AS 'Snapshot Count',
	ROUND(SUM(y.RealDataUsed), 2) AS 'Actual Used Capacity without Dedupe (GB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
JOIN 	dwh_capacity.storage_pool_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_Capacity.date_dimension.latest = 1
JOIN	(
	SELECT 	dwh_capacity.storage_pool_dimension.tk StoragePoolTk,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024 capacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024 usedCapacityGB
	FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
	JOIN 	dwh_Capacity.storage_pool_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_Capacity.storage_pool_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_Capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	GROUP BY dwh_capacity.storage_pool_dimension.tk
	) X
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = x.StoragePoolTk
JOIN
	(
	SELECT 	dwh_capacity.storage_pool_dimension.tk StoragePoolTk,
		dwh_capacity.internal_volume_dimension.tk,
		dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 CapacityGB,
		dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 UsedCapacityGB,
		dwh_capacity.internal_volume_capacity_fact.dedupeRatio Dedupe,
		(1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio DedupeSavingsRatio,
		dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 * ((1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio) SavingsGB,
		((dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024)/(dwh_capacity.internal_volume_capacity_fact.dedupeRatio)) * (SUM(dwh_capacity.internal_volume_capacity_fact.snapshotCount) + 1) RealDataUsed,
		SUM(dwh_capacity.internal_volume_capacity_fact.snapshotCount) SnapshotCount,
		SUM(dwh_capacity.internal_volume_capacity_fact.snapshotAllocatedCapacityMB)/1024 SnapshotAllocatedGB
	FROM 	dwh_capacity.internal_volume_capacity_fact
	JOIN 	dwh_capacity.storage_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_capacity.internal_volume_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	GROUP BY dwh_capacity.internal_volume_dimension.tk
	) Y
ON 	dwh_capacity.storage_pool_dimension.tk = y.StoragePoolTk
GROUP BY 	dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Allocated Pool Capacity (GB)"/><mdProjectedItem name="Used Pool Capacity (GB)"/><mdProjectedItem name="Utilization (%)"/><mdProjectedItem name="Allocated FlexVol Capacity (GB)"/><mdProjectedItem name="Subscription (%)"/><mdProjectedItem name="Dedupe Savings (GB)"/><mdProjectedItem name="Snapshot Count"/><mdProjectedItem name="Actual Used Capacity without Dedupe (GB)"/></mdProjectedItems></sqlQuery></source>
						<selection><dataItem name="Array"><expression>[SQL1].[Array]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Aggregate"><expression>[SQL1].[Aggregate]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Allocated Pool Capacity (GB)"><expression>[SQL1].[Allocated Pool Capacity (GB)]/1024</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Used Pool Capacity (GB)"><expression>[SQL1].[Used Pool Capacity (GB)]/1024</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Utilization (%)"><expression>[SQL1].[Utilization (%)]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Allocated FlexVol Capacity (GB)"><expression>[SQL1].[Allocated FlexVol Capacity (GB)]/1024
</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Subscription (%)"><expression>[SQL1].[Subscription (%)]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Dedupe Savings (GB)"><expression>[SQL1].[Dedupe Savings (GB)]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="9"/><XMLAttribute name="RS_dataUsage" output="no" value="3"/></XMLAttributes></dataItem><dataItem name="Presented Capacity (GB)"><expression>[SQL1].[Actual Used Capacity without Dedupe (GB)]</expression></dataItem></selection>
					</query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:red;font-size:12pt;font-weight:bold"/></style><reportCondition>[Capacity].[Subscription %]&gt;1.5</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:#FF9900;font-weight:bold;font-size:12pt"/></style><reportCondition>[Capacity].[Used %]&gt;.79</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles></report>